alter table Candidates add IsCandidate bit not null default(0)
go

alter table Candidates add IsContactPerson bit not null default(0)
go

update Candidates set
 IsCandidate = 1
 go
  
alter table Candidates add DLC datetime null 
go